package com.ktjiaoyu.crm.repository;

import com.ktjiaoyu.crm.entity.User;
import com.ktjiaoyu.crm.vo.UserInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

/**
 * @InterfaceName : UserRespository
 * @Description :
 * @Author : Lzz
 * @Date: 2023/11/13 09:33:39
 */
public interface UserRepository extends JpaRepository<User,Long> {

    /*@Query("select u.usrId as usrId,u.usrName as usrName,u.usrPassword as usrPassword,u.usrRoleId as usrRoleId,u.usrFlag as usrFlag,r.roleName as roleName " +
            " from User u,Role r where u.usrRoleId=r.roleId and u.usrId=?1")
    UserInfo getUserInfo(Long usrId);*/

}
